Copy file
Purpose of this building block
The Copy File building block creates a copy of a selected file in your Google Drive.
2 variables
1 variables
${folderId}
${fileId}
${fileId}
Possible use cases
- Create a copy to keep your original template files (e.g. a monthly timesheet)
- Create customer individual copies
Configuration
Click on the bold text in the title of the building block to open the configuration dialog.
Useful combinations
To specify the original file you may for example use the Find File building block. After having selected the original file you need to specify the target folder and name of the file copy.
When working with file templates - for example a monthly time sheet - you would like to create a copy for every employee and every month. Therefore use the Find File building block to find the correct template and create a copy to enter the current data. Also when working with Google Forms you may want to create user specific copy of a source form.
Automatically create template copies for timesheets
Form
user
date
task
hours
user
templateFileId
date
Working hours should be recorded for each user. The user data should be separated by month so each employee should have an individual timesheet for every month.
In this example the data is recorded in a form. The data is then added to a timesheet for which the name contains employee name and month. So before the data is added the Find File building block checks if a file for the inserted date and the given employee already exists.
In order not to rely on spelling mistakes the employee make could also be loaded from a worksheet (Load worksheet) or from a Google contacts group (Load contact group) in order to be available as a drop down selection.
timesheetFileId
In case the file cannot be found the template file used to create a new copy for the relevant timesheet the employee working hours need to be added to.
templateFileId
templateFileId
timesheetFileId
timesheetFileId
Timesheet
date
task
hours
After either the existing timesheet was found or a new file was copied the working hours are added to the given file.
Copy the Collect Timesheet Data app to see this building block in action
Questions and Feedback
If you have any comments on this guide, feel free to add them right to the Google document that we are using to create this site.
If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.
Last Updated:
